package com.mingdao.lhy;

import javax.sql.DataSource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;

@Configuration
public class DruidConfiguration {

	private static final Logger logger = LoggerFactory.getLogger(DruidConfiguration.class);

	@Value("${spring.datasource.wish.jdbc-url}")
	private String dbUrl;
	@Value("${spring.datasource.wish.username}")
	private String username;
	@Value("${spring.datasource.wish.password}")
	private String password;
	@Value("${spring.datasource.wish.driver-class-name}")
	private String driverClassName;
	
//	@Value("${spring.datasource.urp.url}")
//	private String dbUrlOracle;
//	@Value("${spring.datasource.urp.username}")
//	private String usernameOracle;
//	@Value("${spring.datasource.urp.password}")
//	private String passwordOracle;
//	@Value("${spring.datasource.urp.driver-class-name}")
//	private String driverClassNameOracle;
//	
//	@Value("${spring.datasource.postgres.url}")
//	private String dbUrlPostgres;
//	@Value("${spring.datasource.postgres.username}")
//	private String usernamePostgres;
//	@Value("${spring.datasource.postgres.password}")
//	private String passwordPostgres;
//	@Value("${spring.datasource.postgres.driver-class-name}")
//	private String driverClassNamePostgres;
	// @Value("${spring.datasource.initialSize}")
	// private int initialSize;
	// @Value("${spring.datasource.minIdle}")
	// private int minIdle;
	// @Value("${spring.datasource.maxActive}")
	// private int maxActive;
	// @Value("${spring.datasource.maxWait}")
	// private int maxWait;
	// @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")
	// private int timeBetweenEvictionRunsMillis;
	// @Value("${spring.datasource.minEvictableIdleTimeMillis}")
	// private int minEvictableIdleTimeMillis;
	// @Value("${spring.datasource.validationQuery}")
	// private String validationQuery;
	// @Value("${spring.datasource.testWhileIdle}")
	// private boolean testWhileIdle;
	// @Value("${spring.datasource.testOnBorrow}")
	// private boolean testOnBorrow;
	// @Value("${spring.datasource.testOnReturn}")
	// private boolean testOnReturn;
	// @Value("${spring.datasource.poolPreparedStatements}")
	// private boolean poolPreparedStatements;
	// @Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}")
	// private int maxPoolPreparedStatementPerConnectionSize;
	// @Value("${spring.datasource.filters}")
	// private String filters;
	// @Value("{spring.datasource.connectionProperties}")
	// private String connectionProperties;

	@Bean // 声明其为Bean实例
	@Primary // 在同样的DataSource中，首先使用被标注的DataSource
	public DataSource dataSource() {
		DruidDataSource datasource = new DruidDataSource();
		datasource.setUrl(this.dbUrl);
		datasource.setUsername(username);
		datasource.setPassword(password);
		datasource.setDriverClassName(driverClassName);
		
//		datasource.setUrl(this.dbUrlPostgres);
//		datasource.setUsername(usernamePostgres);
//		datasource.setPassword(passwordPostgres);
//		datasource.setDriverClassName(driverClassNamePostgres);

		// configuration
		// datasource.setInitialSize(initialSize);
		// datasource.setMinIdle(minIdle);
		// datasource.setMaxActive(maxActive);
		// datasource.setMaxWait(maxWait);
		// datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
		// datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
		// datasource.setValidationQuery(validationQuery);
		// datasource.setTestWhileIdle(testWhileIdle);
		// datasource.setTestOnBorrow(testOnBorrow);
		// datasource.setTestOnReturn(testOnReturn);
		// datasource.setPoolPreparedStatements(poolPreparedStatements);
		// datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
		// try {
		// datasource.setFilters(filters);
		// } catch (SQLException e) {
		// System.err.println("druid configuration initialization filter: " + e);
		// }
		// datasource.setConnectionProperties(connectionProperties);
		return datasource;
	}

//	@Bean // 声明其为Bean实例
	//@Primary // 在同样的DataSource中，首先使用被标注的DataSource
//	public DataSource dataSourceOracle() {
//		DruidDataSource datasource = new DruidDataSource();
//		datasource.setUrl(this.dbUrlOracle);
//		datasource.setUsername(usernameOracle);
//		datasource.setPassword(passwordOracle);
//		datasource.setDriverClassName(driverClassNameOracle);

		// configuration
		// datasource.setInitialSize(initialSize);
		// datasource.setMinIdle(minIdle);
		// datasource.setMaxActive(maxActive);
		// datasource.setMaxWait(maxWait);
		// datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
		// datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
		// datasource.setValidationQuery(validationQuery);
		// datasource.setTestWhileIdle(testWhileIdle);
		// datasource.setTestOnBorrow(testOnBorrow);
		// datasource.setTestOnReturn(testOnReturn);
		// datasource.setPoolPreparedStatements(poolPreparedStatements);
		// datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
		// try {
		// datasource.setFilters(filters);
		// } catch (SQLException e) {
		// System.err.println("druid configuration initialization filter: " + e);
		// }
		// datasource.setConnectionProperties(connectionProperties);
//		return datasource;
//	}
	
	@Bean
	public ServletRegistrationBean<StatViewServlet> druidServlet() {
		logger.info("init Druid Servlet Configuration ");
		ServletRegistrationBean<StatViewServlet> servletRegistrationBean = new ServletRegistrationBean<StatViewServlet>(
				new StatViewServlet(), "/druid/*");
		// IP白名单
		// servletRegistrationBean.addInitParameter("allow", "192.168.1.xxx,127.0.0.1");
		// IP黑名单(共同存在时，deny优先于allow)
		// servletRegistrationBean.addInitParameter("deny", "192.168.1.xxx");
		// 控制台管理用户
		servletRegistrationBean.addInitParameter("loginUsername", "admin");
		servletRegistrationBean.addInitParameter("loginPassword", "admin2");
		// 是否能够重置数据 禁用HTML页面上的“Reset All”功能
		servletRegistrationBean.addInitParameter("resetEnable", "false");
		return servletRegistrationBean;
	}

	@Bean
	public FilterRegistrationBean<WebStatFilter> filterRegistrationBean() {
		// 创建过滤器
		FilterRegistrationBean<WebStatFilter> filterRegistrationBean = new FilterRegistrationBean<>(
				new WebStatFilter());
		// 设置过滤器过滤路径
		filterRegistrationBean.addUrlPatterns("/*");
		// 忽略过滤的形式
		filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
		return filterRegistrationBean;
	}
}